﻿CREATE PROCEDURE [dbo].[IsValidCustomer]
@customerID INT, @uid VARCHAR (50), @pwd VARCHAR (50), @valid BIT OUTPUT
AS
if (select count(CustomerID) from vwUsersByCustomer where UserName = @uid and Password = @pwd and CustomerID = @customerID) > 0
begin
select @valid=1
end
else
begin
select @valid = 0
end


